Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-08-06 : 01:31:40
|
| How can i get the column datatyes,Constraints list by queryPlese help me |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-06 : 01:41:56
|
| use select * from information_schema.tables as well as information_schema.columns views to get all the required informationArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-08-06 : 01:48:14
|
| select * from INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGEArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
How can i get the column datatyes,Constraints