The data architecture is the biggest headache for website development. Local Development is easy. ProgramYou only need to package the DLL, but the database needs to be transferred to the space server. accidentally, you will forget some stored procedures, triggers, and constraints. here we will provide you with several query checks. it can quickly find out what is missing. very practical. there are good methods, please know.
This statement returns all user tables.
Select * From sysobjects where xtype = 'U' --- query all triggers
Select * From sysobjects where xtype = 'tr' --- query all triggers -- read all table names in the database
Select name from sysobjects where xtype = 'U': How can I obtain all the column names in a table. SQL statement.
Select column name = Name from syscolumns where id = object_id (n' name of the table to be queried ') query all data table information
Use Database Name DB
Select * From sysobjects each object created in the database (constraints, default values, logs, rules, stored procedures, etc.) occupies a row in the table. Each temporary object occupies one row in the table only in tempdb.
