In MySQL it is possible to do show create table tablename
What is the SQL Server equivalent?
Show create table tablename in SQL Server
Viewed 40664
3 Answers
if multiple database and schema exists in SQL_Dataserver, Then you need to provide the exact table location with sp_help within single quotes.
exec sp_help 'database_name.schema_name.table_name'
Related